package com.huike.pmps.dao;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.huike.pmps.model.entity.Region;
import org.apache.ibatis.annotations.Update;

/**
 * 作者：谌贵斌(黑桃K)
 * 日期: 2888-08-08
 * 老师QQ: 272488352
 * 官方QQ交流群: 377748272
 * 刀客程序员官网：http://www.daoke360.com
 * 刀客程序员淘宝旗舰店：https://daoke360.taobao.com/
 */
public interface RegionDao extends BaseMapper<Region> {


    @Update({
            " UPDATE p_po                         SET region_name=#{regionName}  WHERE region_id= #{regionId} ; ",
            " UPDATE p_po_course                  SET region_name=#{regionName}  WHERE region_id= #{regionId} ; ",
            " UPDATE p_po_course_supplier_detail  SET region_name=#{regionName}  WHERE region_id= #{regionId} ; ",
            " UPDATE p_supplier_settlement_detail SET region_name=#{regionName}  WHERE region_id= #{regionId} ; ",
            " UPDATE p_supplier_warehouse_receipt SET region_name=#{regionName}  WHERE region_id= #{regionId} ; ",
            " UPDATE p_course_capacity            SET region_name=#{regionName}  WHERE region_id= #{regionId} ; ",
    })
    int updateDependent(Integer regionId,String regionName);
}
